microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 6

In Excel a fast way to add up this column of number is to click in the cell below the numbers and then

a) Click subtotals on the data menu

b) View the sum in the formula bar

c) Click the autosum button on the standard toolbar, then press enter

d) All of above

Question : 7

In Excel one can copy data or formulas

a) With the copy, paste and cut commands on the edit menu

b) With commands on ta shortcut menu

c) With buttons on the standard toolbars

d) All of the above

Question : 8

In Excel to create a formula, you first

a) Select the cell you want to place the formula into

b) Type the equals sign (=) to tell Excel that you’re about to enter a formula

c) Enter the formula using any input values and the appropriate mathematical operators that make up your formula

d) Choose the new command from the file menu

Question : 9

Tab scroll buttons are place on Excel screen

a) towards the bottom right corner

b) towards the bottom left corner

c) towards the top right corner

d) towards the top left corner

e) None of these

Question : 10

When you link data maintained in an excel workbook to a word document

a) The word document can not be edit

b) The word document contains a reference to the original source application

c) The word document must contain a hyperlink

d) The word document contains a copy of the actual data

e) None of these